██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀                                     
    

Sets - Execution started 22/01/2023 19:23 UTC
By Guilherme Ruiz

---

Table of Contents

• 1  Data aquisition
  • 1.1  Fetch set lists
  • 1.2  Fetch set properties
  • 1.3  Merge data
  • 1.4  Save data
• 3  Check changes
  • 3.1  Load previous data
  • 3.2  Generate changelog
• 4  Data visualization
  • 4.1  Full data
  • 4.2  Set
  • 4.3  Card number
  • 4.4  Name
  • 4.5  Rarity
    • 4.5.1  By unique
    • 4.5.2  By combination
  • 4.6  Print
  • 4.7  Quantity
  • 4.8  Region
  • 4.9  Cover card
  • 4.10  Series
  • 4.11  Set type
  • 4.12  Release
    • 4.12.1  By year
    • 4.12.2  By month
    • 4.12.3  By day
    • 4.12.4  By region
    • 4.12.5  By series
    • 4.12.6  By set type
• 5  Debug
  • 5.1  Has nan name/number
  • 5.2  Has nan rarity
  • 5.3  Has quantity as print
  • 5.4  Has nan release
  • 5.5  Has print as rarity
  • 5.6  Merge failed
• 6  Epilogue
  • 6.1  HTML export

Data aquisition

Fetch set lists

  0%|          | 0/80 [00:00<?, ?it/s]

4120 set lists received - 76 errors

Fetch set properties

  0%|          | 0/96 [00:00<?, ?it/s]

1430 set properties received - 3 errors

Merge data

object 2013-11-21 00:00:00
datetime64[ns] 2013-11-21 00:00:00
Set properties merged

Save data

Data saved

Check changes

Load previous data

File loaded

Generate changelog

	Name	Rarity	Print	Modification date	Version
Card number
CL03-SC004	<NA>	NaN	<NA>	2022-11-07 13:43:33	Old
CL03-SC004	<NA>	NaN		2022-11-07 13:43:33	New
CL03-SC005	<NA>	NaN	<NA>	2022-11-07 13:43:33	Old
CL03-SC005	<NA>	NaN		2022-11-07 13:43:33	New
CL03-SC006	<NA>	NaN	<NA>	2022-11-07 13:43:33	Old
...	...	...	...	...	...
RD/KP12-JP030	Transamuroad Rainac	(Ultra Rare, Rr)	<NA>	2023-01-21 08:27:32	New
RD/KP12-JP035	The Dragiastar	(Ultra Rare, Rr)	<NA>	2023-01-21 08:27:32	New
RD/KP12-JP035	The Dragiastar	(Ultra Rare, Rush Rare)	<NA>	2023-01-20 13:35:46	Old
RD/KP12-JP041	Drukmoor the Skysavior Phantom	(Rare,)	<NA>	2023-01-20 13:35:46	Old
RD/KP12-JP041	Drukmoor the Skysavior Phantom	(Common,)	<NA>	2023-01-21 08:27:32	New

336 rows × 5 columns

Changelog saved

Data visualization

Full data

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
0	2013 Collectible Tins Wave 2	CT10-FR003	Redox, Dragon Ruler of Boulders	(Secret Rare,)	<NA>	<NA>	FR	2013-11-21	<NA>	Collectible tin	(Redox, Dragon Ruler of Boulders, Tempest, Dra...	https://yugipedia.com/wiki/2013_Collectible_Ti...	2022-04-26 06:56:18	both
1	2013 Collectible Tins Wave 2	CT10-FR012	Diamond Dire Wolf	(Super Rare,)	<NA>	<NA>	FR	2013-11-21	<NA>	Collectible tin	(Redox, Dragon Ruler of Boulders, Tempest, Dra...	https://yugipedia.com/wiki/2013_Collectible_Ti...	2022-04-26 06:56:18	both
2	2013 Collectible Tins Wave 2	CT10-FR013	Number 88: Gimmick Puppet of Leo	(Super Rare,)	<NA>	<NA>	FR	2013-11-21	<NA>	Collectible tin	(Redox, Dragon Ruler of Boulders, Tempest, Dra...	https://yugipedia.com/wiki/2013_Collectible_Ti...	2022-04-26 06:56:18	both
3	2013 Collectible Tins Wave 2	CT10-FR014	Spellbook of the Master	(Super Rare,)	<NA>	<NA>	FR	2013-11-21	<NA>	Collectible tin	(Redox, Dragon Ruler of Boulders, Tempest, Dra...	https://yugipedia.com/wiki/2013_Collectible_Ti...	2022-04-26 06:56:18	both
4	2013 Collectible Tins Wave 2	CT10-FR004	Tempest, Dragon Ruler of Storms	(Secret Rare,)	<NA>	<NA>	FR	2013-11-21	<NA>	Collectible tin	(Redox, Dragon Ruler of Boulders, Tempest, Dra...	https://yugipedia.com/wiki/2013_Collectible_Ti...	2022-04-26 06:56:18	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
156161	Jump Festa 2007 promotional cards	JF07-JP001	Voltic Kong	(Common, Normal Parallel Rare)	<NA>	<NA>	JP	2006-12-16	<NA>	Promotional card	NaN	https://yugipedia.com/wiki/Jump_Festa_2007_pro...	2019-03-13 23:29:15	both
156162	Jump Festa 2007 promotional cards	JF07-JP002	Botanical Lion	(Common, Normal Parallel Rare)	<NA>	<NA>	JP	2006-12-16	<NA>	Promotional card	NaN	https://yugipedia.com/wiki/Jump_Festa_2007_pro...	2019-03-13 23:29:15	both
156163	Jump Festa 2007 promotional cards	JF07-JP003	Gravity Behemoth	(Common, Normal Parallel Rare)	<NA>	<NA>	JP	2006-12-16	<NA>	Promotional card	NaN	https://yugipedia.com/wiki/Jump_Festa_2007_pro...	2019-03-13 23:29:15	both
156164	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Academia_Disk	2022-12-28 20:46:20	right_only
156165	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Structure_Deck:_Mar...	2014-07-03 18:52:14	right_only

156166 rows × 14 columns

Full data available here

Set

Total number of sets: 1435

	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Set
"Amabie-San" Present Campaign	2	1	1	0	0	1	1	0	1	0	1	1	1
"Blue-Eyes White Dragon Rush Rare Special Red Version" GET Campaign	2	1	1	0	0	2	2	0	1	0	1	1	1
"Blue-Eyes White Dragon Secret Rare Special Blue Version" GET Campaign	1	1	1	0	0	1	1	0	1	0	1	1	1
"Blue-Eyes White Dragon" 20th Anniversary Gold Edition	0	1	0	0	0	1	1	0	1	0	1	1	1
"Blue-Eyes White Dragon" 20th Anniversary Silver Edition	0	1	0	0	0	1	1	0	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Yu-Gi-Oh! ZEXAL World Duel Carnival Duel Champion Guide! promotional card	1	1	1	0	0	1	1	0	1	0	1	1	1
Yu-Gi-Oh! ZEXAL World Duel Carnival promotional cards	18	3	1	0	0	6	2	0	1	0	1	1	1
Yugi's Legendary Decks	650	112	3	0	0	5	2	0	1	0	1	1	1
Zexal Collection Tin	120	24	3	0	0	5	1	0	1	1	1	1	1
Zombie World Structure Deck	185	37	2	0	2	5	1	0	1	1	1	1	1

1435 rows × 13 columns

	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
count	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.000000	1435.0
mean	107.214634	27.544251	2.429965	0.349826	0.099652	2.696864	1.455052	0.390941	0.953310	0.310801	0.994425	0.994425	1.0
std	236.083779	45.354992	2.329801	0.814096	0.456435	2.298980	0.997155	0.488131	0.211047	0.462983	0.074483	0.074483	0.0
min	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.0
25%	1.000000	1.000000	1.000000	0.000000	0.000000	1.000000	1.000000	0.000000	1.000000	0.000000	1.000000	1.000000	1.0
50%	10.000000	5.000000	1.000000	0.000000	0.000000	1.000000	1.000000	0.000000	1.000000	0.000000	1.000000	1.000000	1.0
75%	86.000000	40.500000	3.000000	0.000000	0.000000	5.000000	2.000000	1.000000	1.000000	1.000000	1.000000	1.000000	1.0
max	1652.000000	307.000000	17.000000	6.000000	3.000000	10.000000	9.000000	1.000000	1.000000	1.000000	1.000000	1.000000	1.0

Card number

Total number of card numbers: 151987

	Set	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Card number
15AX-JP000	2	1	1	1	0	1	1	0	1	0	2	2	1
15AX-JPM01	1	1	1	1	0	1	1	0	1	0	1	1	1
15AX-JPM02	1	1	1	1	0	1	1	0	1	0	1	1	1
15AX-JPM03	1	1	1	1	0	1	1	0	1	0	1	1	1
15AX-JPM04	1	1	1	1	0	1	1	0	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
ZTIN-SP021	1	1	1	0	0	1	1	0	1	1	1	1	1
ZTIN-SPV01	1	1	1	0	0	1	1	0	1	1	1	1	1
ZTIN-SPV02	1	1	1	0	0	1	1	0	1	1	1	1	1
ZTIN-SPV03	1	1	1	0	0	1	1	0	1	1	1	1	1
<NA>	44	406	6	2	0	10	40	6	11	6	43	43	3

151988 rows × 13 columns

Name

Total number of card names: 12579

	Set	Card number	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Name
"A Legendary Ocean"	1	1	0	0	0	1	1	0	1	1	1	1	1
"A" Cell Breeding Device	4	9	1	1	0	7	6	1	2	3	4	4	1
"A" Cell Incubator	2	8	1	2	0	7	6	1	1	2	2	2	1
"A" Cell Recombination Device	1	8	1	0	0	8	4	1	1	1	1	1	1
"A" Cell Scatter Burst	3	9	1	1	0	7	6	1	1	3	3	3	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Zubaba Knight	12	50	5	1	1	8	23	2	2	7	12	12	1
Zubababancho Gagagacoat	1	2	1	1	0	2	2	1	1	1	1	1	1
Zure, Knight of Dark World	8	24	1	1	1	10	14	1	4	4	8	8	1
Zushin the Sleeping Giant	3	14	3	1	0	8	4	1	2	3	3	3	1
<NA>	9	182	3	1	0	9	12	4	4	4	9	9	2

12580 rows × 13 columns

	Set	Card number	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
count	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000	12579.000000
mean	3.142221	12.069401	2.071786	0.670721	0.112330	6.893871	5.982829	1.089912	1.473567	1.843469	3.130933	3.130933	1.010812
std	3.514576	11.604525	1.494203	0.673424	0.342361	2.561741	5.903301	0.787852	0.937376	1.841657	3.493939	3.493939	0.103420
min	1.000000	0.000000	0.000000	0.000000	0.000000	1.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.000000
25%	1.000000	7.000000	1.000000	0.000000	0.000000	6.000000	3.000000	1.000000	1.000000	1.000000	1.000000	1.000000	1.000000
50%	2.000000	9.000000	2.000000	1.000000	0.000000	8.000000	4.000000	1.000000	1.000000	1.000000	2.000000	2.000000	1.000000
75%	4.000000	14.000000	3.000000	1.000000	0.000000	8.000000	7.000000	1.000000	2.000000	2.000000	4.000000	4.000000	1.000000
max	80.000000	275.000000	28.000000	4.000000	3.000000	15.000000	122.000000	12.000000	16.000000	41.000000	80.000000	80.000000	2.000000

Rarity

Total number of rarities: 55

By unique

	Set	Card number	Name	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Rarity
10000 Secret Rare	2	7	1	1	0	7	2	1	1	2	2	2	1
20th Secret Rare	16	135	134	3	0	1	13	3	3	6	16	16	1
@released::(from July 17)	1	1	1	0	0	1	0	0	0	0	1	1	1
@released::(from July 31)	1	1	1	0	0	1	0	0	0	0	1	1	1
@released::(from September 18)	1	2	1	0	0	1	0	0	0	0	1	1	1
Collector's Rare	6	301	76	2	0	7	6	2	1	6	6	6	1
Collectors Rare	8	112	112	2	0	1	8	1	1	7	8	8	1
Common	556	76875	8562	6	3	17	921	25	23	268	554	554	2
Duel Terminal Normal Parallel Rare	38	1906	511	2	0	7	34	1	3	11	38	38	1
Duel Terminal Normal Rare Parallel Rare	5	15	15	0	0	1	5	0	1	4	5	5	1
Duel Terminal Rare Parallel Rare	34	368	141	2	0	2	31	0	1	10	34	34	1
Duel Terminal Secret Parallel Rare	16	103	55	1	0	1	16	0	1	10	16	16	1
Duel Terminal Super Parallel Rare	34	240	85	2	0	2	31	0	1	10	34	34	1
Duel Terminal Ultra Parallel Rare	42	371	87	2	0	7	33	1	5	18	42	42	1
Extra Secret Parallel Rare	3	10	6	0	0	2	4	0	2	1	3	3	1
Extra Secret Rare	24	77	50	1	1	3	31	3	5	17	24	24	1
Ghost Rare	35	255	47	3	0	7	63	1	2	34	35	35	1
Ghost/Gold Rare	1	30	6	0	0	5	2	1	1	0	1	1	1
Gold Rare	23	2057	363	2	0	9	39	3	5	0	23	23	1
Gold Rush Rare	2	16	16	2	0	1	2	0	1	1	2	2	1
Gold Secret Rare	8	644	154	2	0	9	17	1	3	0	8	8	1
Holographic Parallel Rare	2	2	2	1	0	1	2	0	1	0	2	2	1
Holographic Rare	68	123	65	2	0	6	121	3	2	65	68	68	1
Kaiba Corporation Common	10	10	10	0	0	1	8	0	1	0	10	10	1
Kaiba Corporation Rare	5	5	5	0	0	1	5	1	2	0	5	5	1
Kaiba Corporation Ultra Rare	3	3	3	0	0	1	3	0	2	0	3	3	1
Millennium Gold Rare	2	9	6	2	0	2	2	0	1	2	2	2	1
Millennium Rare	8	316	152	3	0	3	9	2	6	2	8	8	1
Millennium Secret Rare	1	4	2	1	0	2	0	0	1	1	1	1	1
Millennium Super Rare	1	40	20	1	0	2	0	0	1	1	1	1	1
Millennium Ultra Rare	1	16	8	1	0	2	0	0	1	1	1	1	1
Mosaic Rare	1	1290	215	0	0	6	2	0	1	1	1	1	1
New	2	1	18	1	1	1	2	1	2	2	2	2	1
Normal Parallel Rare	131	2071	994	4	1	4	163	7	10	61	131	131	1
Normal Rare	81	575	299	2	0	7	151	3	2	72	81	81	1
Orr	1	1	1	0	0	1	1	1	1	1	1	1	1
Platinum Secret Rare	2	24	4	0	0	6	4	0	1	2	2	2	1
Prismatic Secret Rare	40	1391	367	3	0	11	48	6	4	15	40	40	1
Rare	249	18683	3500	7	2	15	545	13	8	177	248	248	2
Reprint	6	0	35	0	0	1	6	3	1	1	6	6	1
Rr	1	4	4	0	0	1	1	1	1	1	1	1	1
Rush Rare	15	102	47	0	0	2	27	1	2	12	15	15	1
Secret Parallel Rare	2	12	6	1	0	2	4	0	1	0	2	2	1
Secret Rare	373	10358	2293	11	1	15	532	20	20	200	368	368	2
Shatterfoil Rare	4	1482	292	0	1	7	5	1	2	4	4	4	1
Short Print	56	1316	234	3	0	10	110	3	1	46	56	56	1
Starfoil Rare	6	2019	380	0	0	6	9	1	3	4	6	6	1
Starlight Rare	12	316	56	2	0	6	13	1	1	12	12	12	1
Super Parallel Rare	6	154	82	3	1	3	10	1	3	2	6	6	1
Super Rare	585	20264	3888	9	1	17	953	26	20	276	581	581	2
Super Short Print	1	35	5	1	0	7	0	1	1	1	1	1	1
Ultimate Rare	115	4315	847	2	1	11	278	5	6	85	114	114	2
Ultra Parallel Rare	67	279	170	3	1	7	63	4	7	20	66	66	2
Ultra Rare	784	17963	3172	7	2	17	1069	33	26	278	782	782	2
Ultra Secret Rare	1	0	6	0	0	1	1	1	1	0	1	1	1
NaN	36	385	367	3	0	6	30	5	9	4	35	35	3

By combination

	Set	Card number	Name	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Rarity
(10000 Secret Rare,)	2	7	1	1	0	7	2	1	1	2	2	2	1
(20th Secret Rare,)	9	25	24	1	0	1	8	2	3	1	9	9	1
(@released::(from July 17),)	1	1	1	0	0	1	0	0	0	0	1	1	1
(@released::(from July 31),)	1	1	1	0	0	1	0	0	0	0	1	1	1
(@released::(from September 18),)	1	2	1	0	0	1	0	0	0	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
(Ultra Rare, Ultimate Rare, Ultra Parallel Rare)	1	1	1	0	0	1	1	1	1	1	1	1	1
(Ultra Rare, Ultra Parallel Rare)	22	71	67	0	0	1	16	3	2	16	21	21	2
(Ultra Rare, Ultra Parallel Rare, Ultimate Rare)	5	5	5	0	0	1	3	2	1	3	5	5	1
(Ultra Secret Rare,)	1	0	6	0	0	1	1	1	1	0	1	1	1
NaN	36	385	367	3	0	6	30	5	9	4	35	35	3

127 rows × 13 columns

Print

Total number of prints: 18

	Set	Card number	Name	Rarity	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Print
	1	155	0	0	0	1	1	1	1	0	1	1	1
2	1	0	1	0	0	1	1	0	1	1	1	1	1
American debut	1	3	3	1	0	1	1	0	1	1	1	1	1
European & Oceanian debut	1	6	6	1	0	1	1	0	1	0	1	1	1
European debut	12	146	146	5	0	2	10	0	2	1	12	12	1
Functional errata	1	2	2	1	0	1	1	0	1	1	1	1	1
New	226	11750	3867	50	3	11	243	18	13	129	224	224	2
New art	1	4	2	1	0	2	2	0	1	1	1	1	1
New artwork	10	74	15	5	0	7	12	3	4	4	10	10	1
New artwork (renamed)	1	3	3	1	0	1	1	0	1	0	1	1	1
North American debut	2	4	4	2	0	2	2	0	2	0	2	2	1
Oceanian debut	1	1	1	1	0	1	1	0	1	0	1	1	1
Reprint	223	14034	4287	49	3	11	240	17	12	127	221	221	2
Reprint (New Art)	2	2	1	2	0	2	2	1	1	1	2	2	1
Reprint (functional errata)	15	33	21	10	0	8	14	3	3	5	15	15	1
Reprint (new artwork)	1	1	1	1	0	1	1	0	1	1	1	1	1
Reprint (renamed)	2	76	76	6	0	1	2	1	1	0	2	2	1
TCG legal debut	1	1	1	1	0	1	1	1	1	1	1	1	1
<NA>	1355	125869	11478	115	3	17	1451	41	37	315	1347	1347	3

Quantity

Total number of quantities: 3

	Set	Card number	Name	Rarity	Print	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Quantity
1	67	8858	1215	11	2	11	108	1	6	46	66	66	2
2	66	855	173	4	2	11	108	1	6	45	65	65	2
3	10	74	25	1	2	8	12	0	4	8	10	10	1
<NA>	1370	142212	12469	125	18	17	1501	45	36	314	1362	1362	3

Region

Total number of regions: 17

	Set	Card number	Name	Rarity	Print	Quantity	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
Region
AE	34	1527	1493	12	0	2	31	2	7	19	34	34	1
AU	2	100	87	3	0	0	1	0	1	2	2	2	1
DE	455	20372	10393	45	4	3	381	12	18	219	454	454	2
EN	657	20183	10480	51	14	3	535	22	23	207	656	656	2
ES	1	100	100	7	0	0	0	1	1	1	1	1	1
EU	25	543	456	8	3	0	16	2	9	6	25	25	1
FC	3	102	87	3	0	0	1	0	2	2	3	3	1
FR	448	19776	10380	46	4	3	375	14	18	219	447	447	2
IT	447	20051	10388	46	4	3	378	12	18	218	446	446	2
JA	3	185	185	8	0	0	3	2	2	3	3	3	1
JP	715	19090	11213	94	7	3	530	28	28	247	710	710	2
KR	383	15937	10755	55	4	3	333	16	15	224	378	378	2
NA	47	1526	1333	10	4	2	39	5	11	12	47	47	1
PT	204	12461	7823	40	4	3	165	8	10	120	204	204	1
SC	23	1237	1038	12	3	0	23	5	1	12	23	23	1
SP	416	19111	10221	45	4	3	355	9	17	204	415	415	2
TC	7	300	286	12	0	2	5	2	2	3	7	7	1
<NA>	2	0	0	0	0	0	0	0	0	0	2	2	1

	Set	Card number	Name	Rarity	Print	Quantity	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
count	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000
mean	215.111111	8477.833333	4817.666667	27.611111	3.055556	1.666667	176.166667	7.777778	10.166667	95.444444	214.277778	214.277778	1.388889
std	252.453581	9290.544746	5018.925453	25.836907	3.489012	1.414214	203.587313	8.156957	8.759868	105.784032	251.364232	251.364232	0.501631
min	1.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.000000	1.000000	1.000000
25%	4.000000	213.750000	210.250000	8.000000	0.000000	0.000000	3.500000	2.000000	2.000000	3.000000	4.000000	4.000000	1.000000
50%	40.500000	1526.500000	1413.000000	12.000000	3.500000	2.000000	35.000000	5.000000	9.500000	15.500000	40.500000	40.500000	1.000000
75%	439.250000	19105.750000	10386.000000	45.750000	4.000000	3.000000	370.000000	12.000000	17.750000	215.250000	438.250000	438.250000	2.000000
max	715.000000	20372.000000	11213.000000	94.000000	14.000000	3.000000	535.000000	28.000000	28.000000	247.000000	710.000000	710.000000	2.000000

Cover card

Total number of cover cards: 671

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Page URL	Modification date	_merge
Cover card
A-to-Z-Dragon Buster Cannon	1	352	54	4	2	2	8	4	0	1	1	1	1
Accel Synchro Stardust Dragon	1	100	50	3	2	0	2	2	0	1	1	1	1
Accesscode Talker	1	766	101	16	2	0	8	3	1	1	1	1	1
Adamancipator Risen - Dragite	1	135	45	3	2	0	3	3	0	1	1	1	1
Adreus, Keeper of Armageddon	1	84	42	4	0	0	2	2	0	1	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Yamiterasu the Divine Ruler	1	132	66	6	0	0	2	2	1	1	1	1	1
Yoko, the Graceful Mayakashi	2	450	60	4	2	0	8	3	0	1	2	2	1
Yubel - The Ultimate Nightmare	2	560	100	10	0	0	6	5	1	2	2	2	1
Z-Metal Tank	1	55	55	7	0	0	1	1	1	1	1	1	1
Zerrziel, Ruler of the Evil Eyed	1	90	45	3	2	0	2	2	0	1	1	1	1

671 rows × 13 columns

Series

Total number of series: 45

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Set type	Cover card	Page URL	Modification date	_merge
Series
+1 Bonus Pack	7	249	137	3	0	0	2	12	1	0	7	7	1
Animation Chronicle	2	200	100	7	2	0	2	4	1	2	2	2	1
Astral Pack	7	1110	184	4	4	0	6	16	1	0	7	7	1
Attribute Duelist Pack	4	429	199	6	3	0	3	9	1	4	4	4	1
Battle Pack (Rush Duel)	8	80	80	3	3	0	1	8	1	0	8	8	1
Booster (series)	4	181	176	8	0	0	1	4	1	2	4	4	1
Booster pack	1	50	50	3	0	0	1	1	1	0	1	1	1
Champion Pack	8	640	161	4	2	0	4	8	1	0	8	8	1
Classic Pack	3	570	415	9	3	0	1	3	1	2	3	3	1
Collectors Pack	8	794	374	12	3	0	3	16	1	8	8	8	1
Core Booster	88	49929	7471	39	2	0	14	296	1	80	88	88	1
Deck Build Pack	3	360	134	5	2	0	3	8	1	3	3	3	1
Deck Mod Pack	12	1447	756	10	0	0	2	23	1	12	12	12	1
Duelist Pack	21	3739	634	7	3	0	8	49	1	19	21	21	1
Entry Pack (series)	10	163	160	3	2	0	1	10	1	0	10	10	1
Expansion Pack	4	280	280	6	0	0	1	4	1	0	4	4	1
Gold Series (series)	8	2595	446	9	2	0	9	18	1	0	8	8	1
Hidden Arsenal (series)	7	2470	400	2	2	0	7	16	1	7	7	7	1
Hobby League	1	83	43	3	0	0	5	0	1	0	1	1	1
Jump Victory Carnival	1	1	1	1	0	0	1	1	1	0	1	1	1
Legend Duelist (series)	6	780	343	9	2	0	3	14	1	6	6	6	1
Legendary Collection (series)	2	57	19	1	2	0	3	4	1	0	2	2	1
Master Guide promotional cards (series)	4	8	8	1	0	0	1	4	1	0	4	4	1
Mattel Action Figure promotional cards	3	17	16	1	0	0	1	3	1	0	3	3	1
McDonald's Promotional Cards	2	35	35	4	3	0	2	2	1	0	2	2	1
Monster Figure Collection promotional cards	3	15	15	1	0	0	1	3	1	0	3	3	1
OTS Tournament Pack	2	324	54	4	0	0	6	3	1	0	2	2	1
Perfect Rulebook promotional cards	3	3	3	2	0	0	1	3	1	0	3	3	1
Pharaoh Tour promotional cards	3	20	5	2	0	0	4	3	1	0	3	3	1
Premium Pack	25	452	368	9	3	0	2	25	1	12	25	25	1
Shonen Jump promotional cards	78	85	81	2	0	0	2	44	1	0	78	78	1
Sneak Peek Participation Cards	57	302	61	2	0	0	8	69	1	0	57	57	1
Star Pack	3	900	149	4	0	0	6	6	1	3	3	3	1
Structure Deck R	3	248	122	5	2	2	2	6	1	3	3	3	1
The Valuable Book promotional cards	18	38	38	2	0	0	2	19	1	0	18	18	1
V Jump August 1999 Special Present	1	0	6	1	0	0	1	1	1	0	1	1	1
V Jump Edition (series)	4	16	16	3	0	0	1	4	1	0	4	4	1
V Jump promotional cards	78	94	98	5	0	0	1	74	1	0	78	78	1
Value Box	9	11	11	3	0	0	1	7	1	0	9	9	1
Yu-Gi-Oh! 5D's manga promotional cards	9	19	9	1	0	0	3	18	1	0	9	9	1
Yu-Gi-Oh! Day promotional cards	7	7	1	1	0	0	2	7	1	0	7	7	1
Yu-Gi-Oh! GX manga promotional cards	9	19	9	2	0	0	3	17	1	0	9	9	1
Yu-Gi-Oh! R promotional cards	4	8	4	2	0	0	2	8	1	0	4	4	1
Yu-Gi-Oh! World Championship prize cards	13	35	30	5	0	0	3	13	1	0	13	13	1
Yu-Gi-Oh! ZEXAL manga promotional cards	8	25	8	1	0	0	4	25	1	0	8	8	1

Set type

Total number of set types: 37

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Cover card	Page URL	Modification date	_merge
Set type
Beta set	1	535	106	1	0	2	5	1	0	0	1	1	1
Binder	2	6	6	2	2	0	1	2	0	0	2	2	1
Book promotional card	4	5	5	3	0	0	2	4	1	0	4	4	1
Book promotional cards	26	52	52	4	0	0	2	27	2	0	26	26	1
Booster pack	467	114012	11764	104	16	0	15	809	23	223	467	467	1
Boss Duel Deck	1	8	8	1	0	0	1	1	0	0	1	1	1
Bundle	9	11	11	3	0	0	1	7	1	0	9	9	1
Collectible tin	53	5901	1005	9	4	0	8	66	0	35	53	53	1
Collector's Set	11	6226	1102	7	2	3	7	14	0	6	11	11	1
Core Booster	1	160	80	6	0	0	2	2	0	1	1	1	1
Deluxe Edition	4	114	19	2	0	0	6	8	0	4	4	4	1
Demo Deck	4	380	64	1	0	0	7	8	0	1	4	4	1
Duel Disk	2	16	9	2	2	0	2	4	0	0	2	2	1
Duel Disk promotional cards	5	13	12	4	0	0	2	5	0	0	5	5	1
Duel Terminal	34	1847	706	6	2	0	2	31	0	10	34	34	1
Duelist League participation cards	10	60	16	3	0	0	9	9	0	0	10	10	1
Duelist Set	5	312	154	5	0	2	2	5	0	5	5	5	1
Enhancement Pack	2	20	20	1	0	0	1	1	0	0	2	2	1
Hobby League participation cards	40	83	43	3	0	0	5	38	0	0	40	40	1
Magazine promotional card	167	191	173	9	0	0	3	127	3	7	167	167	1
Magazine promotional cards	4	4	4	1	0	0	2	2	0	0	4	4	1
Main Deck	2	44	44	2	0	0	1	2	0	1	2	2	1
Manga promotional card	33	74	32	2	0	0	4	69	4	0	33	33	1
Participation card	60	485	119	5	0	0	9	71	2	0	60	60	1
Preconstructed Deck	6	401	223	10	3	3	2	8	0	4	6	6	1
Prize card	16	46	41	5	0	0	3	16	1	0	16	16	1
Prize cards	1	68	20	1	0	0	5	1	0	0	1	1	1
Promotional card	140	317	209	18	3	0	9	141	6	21	140	140	1
Promotional cards	25	200	62	7	2	0	10	34	1	1	25	25	1
Special Edition	90	1189	289	9	5	0	10	109	0	1	90	90	1
Starter Deck	38	6777	606	11	3	3	14	59	0	26	38	38	1
Structure Deck	64	9454	1206	9	2	3	10	117	1	45	64	64	1
Tournament prize card	1	2	2	1	0	0	1	1	0	0	1	1	1
Tournament promotional card	2	5	2	2	0	0	2	2	0	0	2	2	1
Vendor Edition	6	210	210	2	0	0	1	6	0	0	6	6	1
Video game promotional card	9	79	39	4	0	0	8	15	0	0	9	9	1
Video games promotional card	23	325	73	4	2	0	9	43	0	0	23	23	1

Release

Total number of release dates: 1572

	Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Set type	Cover card	Page URL	Modification date	_merge
Release
1999-03-01	1	0	40	1	0	0	1	1	1	0	1	1	1
1999-03-18	1	0	1	0	0	0	1	0	1	0	1	1	1
1999-04-29	1	0	1	0	0	0	1	0	1	0	1	1	1
1999-05-05	1	0	1	0	0	0	1	0	1	0	1	1	1
1999-05-25	1	0	40	1	0	0	1	1	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
2023-01-21	1	67	67	7	0	0	1	1	1	1	1	1	1
2023-02-25	1	190	35	5	3	0	1	1	1	0	1	1	1
2023-03-01	3	2	3	2	0	0	1	0	1	0	3	3	1
2023-05-01	3	3	3	1	0	0	1	0	1	0	3	3	1
NaT	120	4071	1175	28	4	2	14	9	13	15	112	112	3

1573 rows × 13 columns

By year

	Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Set type	Cover card	Page URL	_merge
Release
1999	18	0	353	10	2	0	15	8	15	1	18	15
2000	11	268	318	21	2	2	9	7	10	4	11	9
2001	13	311	313	30	7	4	13	5	12	7	13	13
2002	22	1369	1197	81	10	2	21	9	20	14	22	19
2003	51	2669	2263	123	12	0	52	12	41	29	51	38
2004	93	6502	4687	193	6	0	108	27	74	45	93	59
2005	75	7826	4043	160	27	18	127	28	64	37	75	49
2006	102	5244	3048	186	22	20	125	39	93	42	102	67
2007	126	5744	3344	272	16	18	192	53	115	54	126	94
2008	124	5979	3248	267	21	12	194	51	113	50	124	95
2009	117	5104	2973	278	6	14	172	40	111	54	117	93
2010	138	6093	3322	309	8	16	204	58	124	53	138	103
2011	144	6922	3952	318	16	18	214	55	133	53	144	105
2012	141	10271	5425	349	17	20	218	57	128	53	141	111
2013	146	8813	4469	340	18	24	221	68	129	69	146	108
2014	141	12625	5705	381	38	20	225	68	126	60	141	107
2015	136	10432	4828	353	33	12	221	69	125	57	136	103
2016	137	10356	4755	331	39	10	210	62	124	59	137	97
2017	67	8404	3324	198	27	6	140	29	64	35	67	54
2018	46	5413	2129	140	26	0	103	20	41	28	46	41
2019	50	6264	2670	160	29	0	101	17	45	25	50	43
2020	38	6435	2143	150	34	0	85	18	36	27	38	36
2021	65	6812	2733	241	46	6	91	38	53	36	65	49
2022	73	8953	3673	249	66	6	96	43	61	42	73	56
2023	14	797	343	40	8	0	14	7	8	4	14	8

By month

By day

By region

		Set	Card number	Name	Rarity	Print	Quantity	Series	Set type	Cover card	Page URL	Modification date	_merge
Region	Release
AE	2001-06-04	1	0	2	0	0	0	0	0	0	1	1	1
	2002-08-08	2	100	87	3	0	0	0	1	2	2	2	1
	2002-10-24	1	144	144	5	0	0	1	1	1	1	1	1
	2003-04-17	1	3	3	1	0	0	0	1	0	1	1	1
	2003-06-26	1	105	105	5	0	0	1	1	1	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
TC	2014-01-29	1	40	40	4	0	2	0	1	1	1	1	1
	2014-05-01	1	20	20	4	0	0	1	1	0	1	1	1
	2015-03-01	2	40	26	1	0	0	0	0	0	2	2	1
	2015-08-29	1	100	100	6	0	0	1	1	1	1	1	1
	2015-12-05	1	100	100	6	0	0	1	1	1	1	1	1

3171 rows × 12 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Region
AE	0	0	1	3	4	3	3	5	2	1	4	1	1	1	1	1	1	0	0	0	0	0	0	0	0
AU	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
DE	0	0	0	0	8	21	22	17	31	27	23	28	31	30	28	30	27	28	20	15	13	10	8	7	1
EN	0	0	2	2	3	16	29	48	50	45	33	45	47	49	42	43	34	35	20	15	13	10	12	11	1
EU	0	0	0	2	2	4	0	0	0	2	0	2	0	0	0	2	2	1	0	0	0	0	0	0	0
FC	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
FR	0	0	0	0	5	20	22	17	31	27	23	27	28	30	29	28	27	28	19	15	13	10	8	7	1
IT	0	0	0	0	5	20	21	17	31	27	23	27	29	30	28	28	27	28	20	15	13	10	8	7	1
JA	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0
JP	18	11	10	11	11	20	24	27	32	40	40	49	46	44	49	43	43	52	14	16	20	14	25	26	10
KR	0	0	0	0	2	8	7	13	20	24	21	21	30	29	29	23	22	21	17	10	12	10	23	26	1
NA	0	0	0	5	16	6	0	2	2	1	2	1	1	0	0	2	3	0	2	0	0	0	0	0	0
PT	0	0	0	0	0	10	6	0	0	0	0	0	0	1	24	24	25	26	18	14	13	9	8	7	1
SC	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4	7	10	2
SP	0	0	0	0	4	20	20	10	24	22	21	27	27	30	27	28	27	28	19	14	13	10	9	7	1
TC	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	4	0	0	0	0	0	0	0	0

By series

		Set	Card number	Name	Rarity	Print	Quantity	Region	Set type	Cover card	Page URL	Modification date	_merge
Series	Release
+1 Bonus Pack	2020-10-31	1	19	19	3	0	0	1	1	0	1	1	1
	2021-02-04	1	20	20	3	0	0	1	1	0	1	1	1
	2021-04-17	1	19	19	3	0	0	1	1	0	1	1	1
	2021-07-17	1	19	19	3	0	0	1	1	0	1	1	1
	2021-07-21	1	19	19	3	0	0	1	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Yu-Gi-Oh! ZEXAL manga promotional cards	2015-09-01	1	1	1	1	0	0	1	1	0	1	1	1
	2015-10-03	1	1	1	1	0	0	1	1	0	1	1	1
	2015-12-18	1	1	1	1	0	0	1	1	0	1	1	1
	2016-03-01	1	1	1	1	0	0	1	1	0	1	1	1
	2016-09-06	1	1	1	1	0	0	1	1	0	1	1	1

888 rows × 12 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Series
+1 Bonus Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	6	4	1
Animation Chronicle	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	0
Astral Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5	8	3	0	0	0	0	0	0	0	0
Attribute Duelist Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	3	4	0
Battle Pack (Rush Duel)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	4	1
Booster (series)	0	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Booster pack	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Champion Pack	0	0	0	0	0	0	0	1	3	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Classic Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1
Collectors Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	2	2	2	2	2	2	0	0	0
Core Booster	6	0	2	6	11	22	17	17	25	13	14	15	14	16	18	16	17	16	12	10	8	6	8	8	1
Deck Build Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	6	0
Deck Mod Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4	9	8	2
Duelist Pack	0	0	0	0	0	0	2	9	9	10	4	6	7	3	3	1	3	5	1	0	0	0	0	0	0
Entry Pack (series)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	4	4	1
Expansion Pack	0	0	0	0	0	0	0	0	0	3	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0
Gold Series (series)	0	0	0	0	0	0	0	0	0	2	0	2	3	2	0	5	2	2	0	0	0	0	0	0	0
Hidden Arsenal (series)	0	0	0	0	0	0	0	0	0	0	1	3	6	3	3	0	0	0	0	0	0	0	0	0	0
Jump Victory Carnival	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0
Legend Duelist (series)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	4	4	1	1	1	0
Legendary Collection (series)	0	0	0	0	0	0	0	0	0	0	0	2	2	0	0	0	0	0	0	0	0	0	0	0	0
Master Guide promotional cards (series)	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0
Mattel Action Figure promotional cards	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
McDonald's Promotional Cards	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Monster Figure Collection promotional cards	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0
OTS Tournament Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0
Perfect Rulebook promotional cards	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0
Pharaoh Tour promotional cards	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Premium Pack	0	2	2	0	0	3	1	1	1	2	2	2	1	2	2	2	2	0	0	0	0	0	0	0	0
Shonen Jump promotional cards	0	0	0	0	0	0	2	3	4	3	2	7	2	4	4	6	4	6	1	0	0	0	0	0	0
Sneak Peek Participation Cards	0	0	0	0	0	0	4	4	9	8	3	4	4	5	4	4	4	5	5	3	2	1	0	0	0
Star Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	1	2	0	0	0	0	0	0	0	0
Structure Deck R	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	4	1	0	0	0	0	0	0
The Valuable Book promotional cards	1	1	0	2	1	1	1	1	1	1	1	1	1	1	2	1	1	0	1	0	0	0	0	0	0
V Jump August 1999 Special Present	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
V Jump Edition (series)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	1	1	0	0	0	0
V Jump promotional cards	0	0	0	0	0	0	0	0	0	5	7	7	7	8	10	8	11	13	2	0	0	0	0	0	0
Value Box	0	0	0	0	0	0	0	0	0	0	0	0	1	2	4	1	1	0	0	0	0	0	0	0	0
Yu-Gi-Oh! 5D's manga promotional cards	0	0	0	0	0	0	0	0	0	0	0	2	2	3	4	3	3	1	0	0	0	0	0	0	0
Yu-Gi-Oh! Day promotional cards	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	2	1	0	0	0	0	0	0
Yu-Gi-Oh! GX manga promotional cards	0	0	0	0	0	0	0	1	2	3	3	4	3	2	0	0	0	0	0	0	0	0	0	0	0
Yu-Gi-Oh! R promotional cards	0	0	0	0	0	0	1	1	1	1	1	3	0	0	0	0	0	0	0	0	0	0	0	0	0
Yu-Gi-Oh! World Championship prize cards	0	0	0	0	0	1	1	1	1	1	1	1	1	1	1	1	1	1	0	0	0	0	0	0	0
Yu-Gi-Oh! ZEXAL manga promotional cards	0	0	0	0	0	0	0	0	0	0	0	0	0	4	6	6	7	2	0	0	0	0	0	0	0

By set type

		Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Cover card	Page URL	Modification date	_merge
Set type	Release
Beta set	2017-10-04	1	535	106	1	0	2	5	0	0	1	1	1
Binder	2012-09-21	1	3	3	1	2	0	1	0	0	1	1	1
	2015-04-29	1	3	3	1	0	0	1	0	0	1	1	1
Book promotional card	2004-12-18	1	2	2	1	0	0	1	0	0	1	1	1
	2014-04-04	1	1	1	1	0	0	1	1	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...	...
Video games promotional card	2011-04-28	1	7	7	1	0	0	1	0	0	1	1	1
	2011-05-10	1	3	3	1	0	0	1	0	0	1	1	1
	2013-12-05	1	3	3	1	0	0	1	0	0	1	1	1
	2014-06-26	1	15	3	1	0	0	5	0	0	1	1	1
	2016-07-16	1	1	1	1	0	0	1	0	0	1	1	1

1865 rows × 12 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Set type
Beta set	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0
Binder	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0
Book promotional card	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0
Book promotional cards	1	2	0	2	1	2	1	1	1	2	1	1	2	1	3	2	2	1	1	0	0	0	0	0	0
Booster pack	6	6	5	10	15	40	34	36	44	43	35	48	53	54	59	65	56	52	38	28	31	31	52	53	8
Boss Duel Deck	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0
Bundle	0	0	0	0	0	0	0	0	0	0	0	0	1	2	4	1	1	0	0	0	0	0	0	0	0
Collectible tin	0	0	0	1	2	2	2	3	3	7	10	6	5	4	7	2	2	2	2	1	2	1	1	1	0
Collector's Set	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	0	0	3	2	1	4	0
Core Booster	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Deluxe Edition	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	6	0	0	0	0	0	0	0	0	0
Demo Deck	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	2	2	0	3	0	0	0	0	0
Duel Disk	0	0	0	0	0	0	0	1	1	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0
Duel Disk promotional cards	0	0	0	0	0	0	0	1	1	0	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Duel Terminal	0	0	0	0	0	0	0	0	0	6	4	7	6	9	2	0	0	0	0	0	0	0	0	0	0
Duelist League participation cards	0	0	0	0	4	4	2	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Duelist Set	0	0	0	0	0	0	0	0	0	0	0	0	0	3	5	1	0	0	0	0	0	0	0	0	0
Enhancement Pack	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0
Hobby League participation cards	0	0	0	0	0	2	1	13	12	12	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Magazine promotional card	1	0	0	0	0	0	3	3	4	10	10	17	10	13	14	14	15	20	3	0	0	0	0	0	0
Magazine promotional cards	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Main Deck	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0
Manga promotional card	0	0	0	1	0	0	1	4	3	4	4	9	5	9	10	9	10	3	0	0	0	0	0	0	0
Participation card	1	0	0	0	0	0	4	4	9	8	4	5	4	5	4	4	4	5	5	3	2	1	0	0	0
Preconstructed Deck	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	1	0	0	4	0
Prize card	0	0	2	0	0	1	1	1	1	1	1	1	2	1	1	1	1	1	0	0	0	0	0	0	0
Prize cards	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0
Promotional card	2	0	2	1	0	1	1	9	8	5	7	14	19	8	5	5	7	17	5	3	6	2	9	11	6
Promotional cards	2	0	1	1	5	7	2	1	0	0	1	4	3	1	3	2	1	0	0	0	1	0	0	0	0
Special Edition	0	0	0	0	2	3	3	7	12	11	13	8	8	12	2	3	7	8	7	4	2	1	0	0	0
Starter Deck	1	1	0	4	13	18	2	0	3	2	5	4	3	4	8	5	7	4	0	0	0	0	2	0	0
Structure Deck	0	0	2	1	3	0	8	10	8	6	7	6	9	9	8	11	13	17	4	0	0	0	0	0	0
Tournament prize card	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Tournament promotional card	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Vendor Edition	0	0	0	0	0	1	2	2	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Video game promotional card	1	2	0	0	0	0	0	0	5	0	3	4	2	0	0	0	0	0	0	0	0	0	0	0	0
Video games promotional card	0	0	0	1	3	8	7	4	8	4	3	0	4	0	1	1	0	1	0	0	0	0	0	0	0

Debug

This section is used for debugging the extraction of data from MediaWiki query responses

Has nan name/number

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
1649	Booster 7	<NA>	Mushroom Man	(Common,)	<NA>	<NA>	JP	2000-03-01	Booster (series)	Booster pack	NaN	https://yugipedia.com/wiki/Booster_7	2022-07-23 09:59:39	both
1650	Booster 7	<NA>	Koumori Dragon	(Reprint,)	<NA>	<NA>	JP	2000-03-01	Booster (series)	Booster pack	NaN	https://yugipedia.com/wiki/Booster_7	2022-07-23 09:59:39	both
1651	Booster 7	<NA>	Jellyfish	(Common,)	<NA>	<NA>	JP	2000-03-01	Booster (series)	Booster pack	NaN	https://yugipedia.com/wiki/Booster_7	2022-07-23 09:59:39	both
1652	Booster 7	<NA>	Grappler	(Common,)	<NA>	<NA>	JP	2000-03-01	Booster (series)	Booster pack	NaN	https://yugipedia.com/wiki/Booster_7	2022-07-23 09:59:39	both
1653	Booster 7	<NA>	Megazowler	(Common,)	<NA>	<NA>	JP	2000-03-01	Booster (series)	Booster pack	NaN	https://yugipedia.com/wiki/Booster_7	2022-07-23 09:59:39	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
145180	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145181	EX Starter Box	<NA>	Castle Walls	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145182	EX Starter Box	<NA>	Ultimate Offering	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
156164	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Academia_Disk	2022-12-28 20:46:20	right_only
156165	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Structure_Deck:_Mar...	2014-07-03 18:52:14	right_only

741 rows × 14 columns

Has nan rarity

array(['Dark Revelation Volume 1', 'Dark Revelation Volume 2',
       'Dark Beginning 1',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome prize cards',
       'Advanced Tournament Pack 2013 Vol.4',
       'Official Guide Starter Book promotional card',
       'Advanced Event Pack 2013 Vol.2',
       'The Valuable Book 1 promotional cards',
       'Duel Monsters II tournament meeting experience promotional card',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome participation cards',
       'Jump Festa 2000', 'Advanced Tournament Pack 2016 Vol.1',
       'Starter Box pre-order promotional card',
       'The Valuable Book character cards',
       'Advanced Event Pack 2014 Vol.1', 'Dark Beginning 2',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome attendance cards',
       'Yu-Gi-Oh! True Duel Monsters: Sealed Memories promotional cards',
       'Advanced Tournament Pack 2013 Vol.3', 'V Jump April 2013 Tokens',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome invitation cards',
       '"Blue-Eyes White Dragon" 20th Anniversary Gold Edition',
       '"Blue-Eyes White Dragon" 20th Anniversary Silver Edition',
       '"Dark Magician" Special Card',
       '"Dark Magician Girl" Special Card',
       '25th Anniversary Ultimate Kaiba Set',
       'Asian-English Weekly Shōnen Jump lottery prize cards',
       'Booster 1', 'Booster 3',
       'Challenge from Kaiba Corporation Clear bonus',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Classic Pack 03', 'Deck Build Pack: Tactical Masters',
       'EX Starter Box', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Has quantity as print

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
145131	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145180	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
145083	EX Starter Box	<NA>	Lord of D.	(New,)	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145084	EX Starter Box	<NA>	The Flute of Summoning Dragon	(New,)	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145085	EX Starter Box	<NA>	Dark Magician	None	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145086	EX Starter Box	<NA>	Mystical Elf	None	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145087	EX Starter Box	<NA>	Feral Imp	None	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
145178	EX Starter Box	<NA>	Reverse Trap	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145179	EX Starter Box	<NA>	Remove Trap	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145180	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145181	EX Starter Box	<NA>	Castle Walls	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both
145182	EX Starter Box	<NA>	Ultimate Offering	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	https://yugipedia.com/wiki/EX_Starter_Box	2022-05-01 06:51:59	both

100 rows × 14 columns

Has nan release

array(['Crossed Souls Sneak Peek Participation Card', 'Ancient Sanctuary',
       'Invasion: Vengeance Sneak Peek Participation Card',
       'Premium Pack 2', 'Shonen Jump Vol. 6, Issue 9 promotional card',
       'Structure Deck: Marik',
       'Yu-Gi-Oh! Power of Chaos: Kaiba the Revenge promotional cards',
       'Astral Pack Two',
       "Yu-Gi-Oh! 5D's World Championship 2011: Over the Nexus promotional cards",
       'Hobby League 6 participation card C',
       'Sneak Peek Participation Cards', 'The Sanctuary in the Sky',
       'Shonen Jump Vol. 4, Issue 2 promotional card',
       'The New Challengers Sneak Peek Participation Card',
       'Astral Pack One', 'Cosmo Blazer',
       'Shadow Specters Sneak Peek Participation Card',
       'Shonen Jump May 2010 subscription bonus',
       'Shonen Jump Vol. 6, Issue 1 promotional card',
       'Secrets of Eternity Sneak Peek Participation Card',
       'Ancient Prophecy Sneak Peek Participation Card',
       'Hobby League 7 participation card C', 'Premium Pack',
       'Spell Ruler', 'Tournament Pack 2009 Vol.3',
       'Tournament Pack 2008 Vol.1', 'Tournament Pack 2009 Vol.4',
       'Ultimate Edition', "Yu-Gi-Oh! 5D's Volume 1 promotional card",
       'Yu-Gi-Oh! GX manga promotional cards',
       'Shonen Jump Vol. 7, Issue 11 promotional card',
       'Structure Deck: Machine Re-Volt Special Edition',
       "Yu-Gi-Oh! 5D's Wheelie Breakers promotional cards",
       'Academy Duel Disk',
       'Shonen Jump Vol. 9, Issue 10 promotional card',
       'Raging Battle Sneak Peek Participation Card',
       'The Valuable Book promotional cards',
       'Yu-Gi-Oh! The Official Magazine promotional cards',
       'Dimension of Chaos Sneak Peek Participation Card',
       'Hobby League 6 participation card D', 'Invader of Darkness',
       'Legacy of the Valiant Sneak Peek Participation Card',
       'Millennium Pack', 'Shonen Jump Championship Series Prize Cards',
       'Shonen Jump Vol. 9, Issue 1 promotional card',
       "Structure Deck: Dinosaur's Rage Special Edition",
       'Duelist League Demo 2010', 'Hobby League 7 participation card D',
       'Tournament Pack 2008 Vol.2', 'Yu-Gi-Oh! R promotional cards',
       'Shonen Jump Vol. 10, Issue 1 promotional card', 'Duel Disk',
       'Shonen Jump Vol. 4, Issue 11 promotional card',
       'Shonen Jump Vol. 7, Issue 6 promotional card',
       'The Lost Millennium: Special Edition',
       'Hobby League 6 participation card E',
       'The Valuable Book character cards',
       'Yu-Gi-Oh! Worldwide Edition: Stairway to the Destined Duel promotional cards',
       'Banzai! promotional cards',
       'Shonen Jump Vol. 3, Issue 6 promotional card',
       'National Championship 2011', 'Curse of Anubis',
       "Yu-Gi-Oh! 5D's manga promotional cards",
       'Shonen Jump Vol. 10, Issue 3 promotional card',
       'Shonen Jump Vol. 4, Issue 12 promotional card',
       'Yu-Gi-Oh! Championship Series Prize Cards',
       'Shonen Jump Vol. 9, Issue 4 promotional card',
       'Hobby League 6 participation card F',
       'Shonen Jump December 2010 subscription bonus',
       'Shonen Jump Vol. 6, Issue 5 promotional card',
       'Hobby League 6 participation card A',
       'Shonen Jump May 2006 subscription bonus',
       'Hobby League participation cards', 'Magic Ruler',
       'Shonen Jump Vol. 3, Issue 9 promotional card',
       'National Championship 2012',
       'Shonen Jump Scholastic Edition Vol. 9, Issue 1 promotional card',
       'Shadow of Infinity: Special Edition',
       'Hobby League 7 participation card A',
       'Shonen Jump Vol. 10, Issue 4 promotional card',
       'Shonen Jump Vol. 5, Issue 1 promotional card', 'Gold Series',
       'Shonen Jump Vol. 7, Issue 9 promotional card',
       'Yu-Gi-Oh! GX Volume 4 promotional card',
       'Shonen Jump Vol. 9, Issue 6 promotional card',
       'Shonen Jump May 2008 subscription bonus',
       'Shonen Jump June/July 2011 subscription bonus',
       'Shonen Jump Vol. 7, Issue 3 promotional card',
       'Hobby League 6 participation card B',
       "Structure Deck: Dinosaur's Rage Special Set",
       'Shonen Jump August 2008 subscription bonus',
       'Shonen Jump Vol. 3, Issue 11 promotional card',
       'National Championship 2013',
       'Hobby League 7 participation card B',
       'Shonen Jump Vol. 5, Issue 6 promotional card',
       '2013 Collectible Tins',
       'Shonen Jump Vol. 9, Issue 8 promotional card',
       '20th Anniversary Duel Set', 'Booster Pack Tin Series Promos',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Collectible Tins 2005', 'Collectible Tins 2006',
       'Collectible Tins 2007', 'Collectible Tins 2008',
       'Collectible Tins 2008 Wave 2', 'Collectible Tins 2009',
       'Collectible Tins 2010', 'Collectible Tins 2011',
       'Collectible Tins 2012',
       'Continuous Token Gifts Promotional Cards', 'Demo Pack',
       'Duelist League 18 participation cards',
       'Duelist League Series 1 participation cards',
       'Duelist League Series 2 participation cards',
       'Duelist Pack: Yugi', 'Exclusive Pack', 'Ghosts From the Past',
       'Judge promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Has print as rarity

array(['Booster 7', 'Structure Deck R: Machine Dragon Re-Volt',
       'Dark Ceremony Edition', 'Booster 4', 'Booster 5', 'Booster 6',
       'Booster 1', 'EX Starter Box'], dtype=object)

Merge failed

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge
156164	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Academia_Disk	2022-12-28 20:46:20	right_only
156165	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	https://yugipedia.com/wiki/Structure_Deck:_Mar...	2014-07-03 18:52:14	right_only

8

array(['2013 Collectible Tins Wave 2', '2016 Mega-Tin Mega Pack',
       'Academy Duel Disk Osiris Red promotional cards', ...,
       'Jump Festa 2007 promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Page URL	Modification date	_merge

Epilogue

Execution completed 22/01/2023 19:32 UTC

HTML export

Notebook saved to disk